-- liquibase formatted sql

-- changeset karmanchikova-ev:0206

ALTER TABLE city ADD UNIQUE (name);
ALTER TABLE client ADD UNIQUE (phone);
ALTER TABLE employee ADD UNIQUE (login);
ALTER TABLE post ADD UNIQUE (name);

ALTER TABLE client DROP COLUMN inn;
ALTER TABLE client DROP COLUMN snils;
ALTER TABLE client DROP COLUMN gender;
ALTER TABLE employee DROP COLUMN gender;

insert into post (id, name)
values (1,'Director'),
       (2,'Tour operation manager'),
       (3,'Travel agent'),
       (4,'Tour guide'),
       (5,'Travel coordinator'),
       (6,'Destination menager'),
       (7,'Marketing specialist'),
       (8,'Reservation manager'),
       (9,'Content creator'),
       (10,'Photographer'),
       (11,'Analyst'),
       (12,'Sales manager'),
       (13,'IT support specialist'),
       (14,'Web developer'),
       (15,'Video producer');




